SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002800s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 602128 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 602128 [ RunTime:0.002720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415142,1015066,1006382,819416,5395,768185,148495,419471,405308,327157,564911,1006999,343013,159460,73098,37022,610170,6485,909040,212540,446528,439392,390665,83387,344342,114465,392118,686773,543407,779283,477848,396262,968366,230529,913438,771279,786559,473574,654486,3526,624045,882466,551499,417088,963554,73699,769743,475154,469804,1037717,746109,822147,406174,56387,948038,13389,947542,846040,1031639,976843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 602128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 602128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]