SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017230 LIMIT 1 [ RunTime:0.001365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017230 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56777,355437,111447,86294,417663,172109,426143,644993,940581,599031,852542,543291,140739,813142,590976,337210,636411,133860,133924,255481,476854,462809,401240,305337,176920,300548,166080,251255,74453,111478,589690,61555,361652,282981,703915,674769,1011094,994671,655268,736494,194946,119096,202735,646796,59813,297318,958776,904639,415322,101390,646856,1025103,768737,942473,254148,813954,93347,3544,131882,312508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000957s ]