SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 212009 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 212009 [ RunTime:0.003894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920609,1020103,62236,325332,10451,735992,347,17363,505094,824951,9540,649059,885265,66928,528920,380423,196556,465910,292665,253692,53119,38807,830186,1045962,1012107,184908,1003084,1010360,39514,899637,856147,368505,896468,555229,674339,785791,464566,17666,111753,202350,411513,27740,44006,716356,413434,764748,531535,339423,1001813,992579,735782,87807,563834,203664,201607,530766,270702,161802,355625,728187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 212009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 212009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001296s ]