SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001814s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540884 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540884 [ RunTime:0.002818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447133,423636,797099,313175,877133,247442,811711,200873,865865,329365,876905,733192,10322,665046,829935,347230,758197,213158,203878,583137,614215,505535,992812,191462,156263,938469,937399,911137,1004588,525268,442620,76827,433783,55260,402023,217726,857199,344529,212185,694439,591526,305455,494883,658852,103201,563570,31349,846676,345268,184342,819419,936739,780707,921109,331334,804108,437887,977371,995991,518957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000810s ]