SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 845748 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 845748 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842501,10989,955962,526101,205391,119823,51133,133156,136915,698160,11266,730298,9630,424226,365242,653792,1047072,385168,195456,203622,884568,1047948,167727,786323,141666,480574,473436,834419,173568,309905,751970,569452,8880,1032791,318073,378066,419749,200969,649754,250654,230257,511717,150019,91211,220914,74882,389833,427400,9183,601564,221629,67920,180802,170842,139040,764252,341129,164120,606270,318198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 845748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 845748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]