SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804493 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804493 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555012,526895,289043,86517,72403,128988,689579,515623,661704,555747,571062,735036,371728,1004694,38610,497899,258923,106504,1000516,324985,345587,54600,320830,924575,713948,603233,372518,265792,11866,135703,918866,146928,741493,165594,81639,607212,314512,438460,728253,83661,555917,234131,858789,500730,403340,769197,252178,504269,372015,973336,402204,153647,645883,201270,294133,761197,298012,222828,581384,378279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003240s ]