SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336690 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336690 [ RunTime:0.002385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448302,497694,927703,485862,679001,604328,861130,718994,988950,111677,73038,396572,91706,746066,411577,115496,815282,803122,612106,956007,995807,906735,257299,732784,378728,744265,357275,453022,978625,478403,632303,617674,743948,471149,114988,743128,528760,316538,951061,228148,412131,65128,634217,881550,456448,952537,866022,917205,407621,485338,978783,167771,958241,791252,294365,170301,424096,608446,460676,914179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001721s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000846s ]