SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544532 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544532 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910285,23577,281605,893227,134268,915633,67714,908661,718025,283031,883239,592332,735692,205699,872688,304121,535611,610211,6010,455839,192827,712058,97989,161509,437490,739911,682347,912053,32996,1038535,867314,215366,684205,115878,561617,466523,193701,884407,246117,699823,377008,363642,488004,391117,1040287,666183,89559,58231,620630,540579,553792,659716,938650,441508,491355,788558,522632,880416,252405,929724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544532 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544532 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]