SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142850 LIMIT 1 [ RunTime:0.000519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142850 [ RunTime:0.002533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996822,856515,507820,853368,926051,425613,786891,691315,547296,130199,67782,581447,170580,579351,128492,422865,384074,102000,933848,399723,808455,809816,1001722,939924,875438,266727,140766,781805,450717,370628,151865,694397,25231,794091,407131,651314,376065,808928,377205,708617,568092,391305,311882,420970,373150,347580,355501,189516,107093,363992,792296,244651,199798,353540,764077,810774,767793,581035,463542,804876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]