SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201665 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201665 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322240,8754,710449,747036,458956,141435,346608,854604,689394,554328,585016,808910,445584,817774,223523,696131,970926,879145,732050,137923,143861,110554,106638,439495,428285,722997,969539,1012608,984197,643926,726484,833948,1012066,121942,1041682,180698,236237,61432,1043009,475112,962783,324750,991127,333431,453681,909541,1002140,213403,352219,214478,88978,355823,530039,300596,685962,579157,798336,766047,559607,859269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201665 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201665 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]