SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48128 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48128 [ RunTime:0.002837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189942,300587,1015185,203084,798472,557172,109081,762688,854685,846181,736786,477627,462827,207025,420824,60575,232523,993243,88564,908024,343250,82419,824326,39110,273270,398811,805081,545798,572284,350547,218238,516485,1047000,392122,11777,334649,495455,966525,317091,342030,216981,983564,77464,147149,435314,767371,406585,529855,831711,358689,14806,753171,344751,61189,9044,290253,95549,758452,235725,119002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]