SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550191 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550191 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552708,183361,781334,860157,473698,861828,732110,751612,731108,227445,371106,825563,795207,46566,698072,1042161,420213,758043,13237,501398,310186,610054,194346,609211,579303,363617,415471,108807,643700,874123,131764,138331,807289,732953,1006730,220088,808661,1028415,11911,892978,917416,133942,450949,256103,246348,683710,184499,131627,545907,45384,877368,977500,177135,762127,192759,336976,201313,649139,1017468,793452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]