SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107263 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107263 [ RunTime:0.004121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (921899,549270,608632,752733,146759,596554,350247,109060,283807,475691,465797,774970,725530,422037,543544,924133,284481,103284,369208,645504,706223,406728,637692,354762,413714,260827,938630,26584,967563,49903,361028,241341,33928,393662,30166,855972,1031388,833040,280906,134873,542203,792966,168127,32910,786298,452663,795997,1028710,422256,723371,17181,985571,960596,47222,871386,444533,445581,781884,194963,130086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001014s ]