SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001582s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 121944 LIMIT 1 [ RunTime:0.000597s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 121944 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353607,1039541,188266,985138,1025477,72652,804785,730685,972018,54941,673368,688956,454088,362528,403643,36340,622645,822930,54858,140316,959973,81218,832876,1018113,420460,275156,1013656,120542,13401,919380,706302,708594,289925,645198,111120,508812,378969,433873,574487,640201,460419,952945,438829,80431,849180,659338,250613,736718,34922,958450,324554,996144,742165,596459,455505,804364,14174,833502,484459,356417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 121944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 121944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000345s ]