SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400701 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400701 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729432,102687,77229,426749,424474,681608,262918,1035369,311306,924754,158640,633214,167138,996553,419796,997111,178702,44066,369842,129763,519216,492214,594029,1041910,387023,728631,904748,642381,441859,157054,347651,153357,510575,577709,865140,332945,532406,802311,298792,709723,943805,120588,450083,751417,576240,820213,783066,518112,524544,663747,1037476,560629,437063,135366,985444,1036644,781416,651621,718077,25470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]