SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022128 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022128 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5049,175694,580861,182818,24356,55497,269604,879498,163465,279350,606155,392697,873604,215520,499803,482783,374944,929570,672262,206456,639513,632143,1014411,482984,128535,384257,111145,329343,372637,198833,616131,727515,22375,4560,201794,151711,315009,872627,778593,26370,689197,734164,921362,83868,672884,952741,113128,701994,782862,716884,616040,612830,322290,159742,832752,931783,671916,126155,790616,60619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]