SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284330 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284330 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362119,814475,295961,587906,317180,809530,822084,502657,123904,944718,445470,866379,872152,1000217,880415,630022,334404,211259,242383,122907,158189,949953,942123,618952,480798,487101,376649,60675,44448,359046,214007,636928,847137,334209,732241,302036,179156,769856,720036,331551,593436,287858,353224,524856,362477,511375,634399,1042691,668040,210728,582535,197549,38057,259450,487320,85545,222308,48299,350756,450458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]