SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019194 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019194 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60168,996900,103780,57061,702483,694665,1026304,309622,843927,967371,232201,48421,1034179,654620,56817,736614,941419,743564,985568,860718,1021620,359637,298646,271651,255093,111287,90347,955641,273945,956796,856202,755772,357876,595567,235012,599193,632869,888630,785371,115971,264340,1032987,1045361,178063,930623,476955,436705,288735,771354,313032,298541,307768,43018,787785,579008,780411,545107,863564,303671,596833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]