SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102931 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102931 [ RunTime:0.003380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951715,975894,610035,135928,348613,298148,106596,875984,831045,760047,590037,596308,984922,1012799,19755,562024,331741,491572,502103,133526,118594,537175,151729,941239,22255,86123,965361,865008,1005110,140263,286032,1046575,624684,1022241,353908,862642,638408,34830,872205,932788,280034,919754,54269,421150,368679,135567,1026400,824325,718786,936765,886008,230487,600899,633720,752598,550676,378305,889416,666255,667385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]