SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10035 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10035 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311967,68519,42115,972752,1038435,943825,231147,382461,844423,542994,548475,540245,463529,966374,413276,61880,577688,77556,426084,430350,1039347,196125,344681,440953,607481,783231,1006926,578223,61253,756504,256385,665376,99455,1017762,554094,82680,209415,573826,788254,492865,393906,56057,462789,1020337,263406,190525,315661,906978,382124,769541,47230,4894,37128,877499,679285,826525,183450,901875,468684,1005855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]