SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043262 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043262 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491978,1048645,661412,1017687,352050,109121,616701,703979,465769,808539,711023,880228,920047,215981,665707,848355,966911,845923,543133,557850,407517,887426,869441,977786,486066,681273,857362,205624,470670,994316,789038,1021869,208614,691902,63020,262550,448580,298778,431351,1046987,38129,312591,764602,289539,560282,850522,527632,657958,653814,135610,1017214,194915,303701,773624,843120,287438,484420,319624,346359,726276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043262 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043262 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001156s ]