SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011422 LIMIT 1 [ RunTime:0.001247s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011422 [ RunTime:0.008178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372804,857318,428925,11825,166294,472651,244206,982001,511258,859458,329657,1026626,1028032,966600,132381,214822,902639,74989,87119,60941,880450,234358,109243,845091,539266,346702,222152,407568,467817,431064,811384,912150,141406,134622,48398,98816,693991,739708,569399,880177,196823,152295,593595,627896,704405,883330,865836,80317,262460,494363,877667,79246,503163,133885,756890,415794,46615,584000,72652,893175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.039574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002282s ]