SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568010 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568010 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193285,532436,80278,313336,606810,172014,166281,510858,257355,636906,819566,503974,51664,962853,43861,663189,412656,335234,147129,748148,700544,86153,755214,978095,4533,93089,314757,168027,378217,87043,20218,980387,437208,75473,1038113,673551,113828,869288,284035,64683,297600,140268,60603,778629,755143,36380,1027497,519907,843084,1028543,525330,558810,696714,108594,447770,1039305,823548,458731,461168,520139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]