SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180910 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180910 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352015,945308,285455,1006776,101433,1030035,144222,1014816,360499,912647,285881,96127,912453,69754,324043,105698,998505,219824,829035,150725,814891,38772,977530,139592,110179,228306,175797,523645,1034670,797176,268493,698725,294384,363668,645238,67088,689684,8438,110163,828643,451899,192475,686428,198753,575883,397260,475678,43262,457829,802886,17488,555377,29864,869654,901592,102879,545356,1009091,447311,1047025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000825s ]