SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423011 LIMIT 1 [ RunTime:0.000580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423011 [ RunTime:0.001421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244925,579394,567324,812638,262579,614258,576531,933057,291700,187641,207292,113990,435954,359227,504067,239965,642755,963857,316433,867631,349349,1004350,399496,205980,705993,513765,797945,838703,300729,162256,611120,628281,915245,413325,1016289,660654,38088,748021,918726,456584,242525,265669,948631,1006117,149888,696712,569707,989246,967415,480888,495680,730994,526525,775777,505999,31271,866035,561167,208290,822837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]