SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 122448 LIMIT 1 [ RunTime:0.001157s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 122448 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420413,131898,157378,729839,578096,459019,1002158,703382,649882,995021,611007,167645,829358,521366,263370,744112,731173,950972,767651,374562,97369,371034,254259,788097,798494,302020,566324,972440,502364,886787,421222,383441,667010,597448,672811,435019,65862,617839,1022109,390840,247637,844372,807431,935831,539302,676199,185390,631980,1038499,249379,159175,65289,664243,555210,809735,133838,328225,914053,606535,429618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 122448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 122448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]