SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420707 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420707 [ RunTime:0.002400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585051,428089,1043766,547625,123897,1041574,553048,183932,808115,1031008,682237,114858,890596,559042,352597,487364,88330,935939,190056,55172,179013,39093,425355,710313,349210,897781,91455,1020529,885656,228666,940111,43503,123889,727304,571367,239045,869727,785954,47276,685270,160819,585043,467577,253847,126007,170729,842045,758008,359014,559842,789779,283148,671422,199298,367761,324870,738131,866671,739038,46443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420707 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420707 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]