SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200750 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200750 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540641,897991,989897,909540,440138,775064,496687,463379,486850,675620,419932,74841,505151,542310,796321,116595,352879,850453,20056,238971,893019,595623,288370,615533,541797,354075,521542,577996,990082,606239,489118,180036,915561,1038012,456127,160153,1008401,636718,550366,50377,624835,451139,144549,890034,951869,433169,1041789,239676,1000390,434438,309145,92063,428068,627421,17844,677091,439827,246343,888548,216172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]