SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302011 LIMIT 1 [ RunTime:0.000998s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302011 [ RunTime:0.005864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343313,643516,847257,439215,372622,813038,42348,189638,760223,755579,770581,525898,54473,791881,723719,504280,830937,228702,347831,570015,788371,498033,618100,609543,138394,648985,617962,77058,425785,277470,854750,997368,553131,485344,940442,638094,981666,391149,538714,532609,360865,728865,843976,562341,1033534,677282,976858,672612,946007,969438,511109,892339,269537,462336,317580,483584,515059,132874,605577,190749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018809s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002143s ]