SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400313 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400313 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410274,801485,927273,508812,1035673,207897,665484,476586,337817,100070,360551,442628,114067,1019873,352484,170660,484547,164285,85718,902902,777948,281819,213186,937565,791143,139533,449916,410080,648593,1047080,722127,839104,936978,844748,826763,769767,390046,217476,544895,694372,952796,1028861,348243,784126,143013,354562,596204,579252,817977,989023,732209,869819,68803,206613,965994,1011959,180364,69357,514911,391988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000727s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003951s ]