SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901980 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901980 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009616,1001917,242474,1038112,505534,722648,377729,715990,140974,277434,222144,269978,531811,95498,296794,536465,401489,849322,228143,915983,11062,626095,304452,737608,77275,715505,675359,963473,602917,131157,47427,276489,908604,121865,324622,728065,95774,404852,670355,805628,283936,40621,150919,326884,1011694,338180,518621,192397,362199,666112,104955,824315,142654,882277,825395,901822,426357,910096,85418,747472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]