SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454693 LIMIT 1 [ RunTime:0.000674s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454693 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111135,174824,4945,645907,320792,547143,533560,665206,516532,510741,681856,91289,851535,439657,492326,833556,716408,588173,559340,186235,610699,816976,1035859,320429,919742,219571,297642,111445,74762,388442,333571,240137,951963,192502,206227,246016,457906,976564,989049,836107,84025,888818,188963,888741,41098,290248,113962,994905,318223,597660,86591,430,888036,311808,33244,956691,356324,565101,424140,39492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]