SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001679s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019694 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019694 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264711,802115,271154,906661,349451,337862,69880,117514,183053,796651,466263,248973,620653,200719,961383,323210,54325,505680,849711,45797,343832,873850,887394,696239,13993,137280,214648,667205,100916,683493,759009,402426,27456,852588,837964,833429,863530,71777,801437,191215,562856,912620,123102,373449,730853,205581,104610,1029149,434394,661611,929230,644292,20539,922804,55291,710278,886463,239924,79614,779403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002461s ]