SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534215 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534215 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006878,876547,458150,752189,479467,1040644,330341,67983,450382,351555,455545,137109,853716,293853,371598,747009,820778,477072,119168,331201,645110,165126,8880,920500,696768,587696,243307,544943,101495,266243,41447,812192,18564,40270,448602,804092,527077,761029,500433,996694,452953,18895,983889,860240,763577,490021,238429,688123,462755,468164,546241,787981,251526,656991,722303,355633,494605,696860,700278,1036861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]