SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001618s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416523 LIMIT 1 [ RunTime:0.000636s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416523 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412864,486128,547069,165994,949785,650732,200422,243137,546727,391323,385171,937894,135046,327224,21022,498955,84323,113625,754905,890334,128824,193613,786594,823890,178260,528570,719908,740394,202453,278856,288095,95679,607555,340473,466509,156464,9926,997473,776873,494676,567809,590277,775011,550712,594125,203311,606632,79680,832525,159362,501037,839295,121458,77515,460320,263550,112824,698615,299226,801808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]