SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814687 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814687 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034383,697406,1027049,707040,243072,7334,1037750,287003,742490,403963,995357,1029862,84372,373247,768546,109031,817581,53148,118647,954173,749946,629245,388474,670997,674915,73543,627866,753694,529894,1010507,184146,594189,526181,961757,261860,155272,891102,2338,834222,636841,566817,513302,268708,251716,367089,351443,735372,422742,512876,279546,920254,400960,1023696,18951,265904,303681,838245,1009150,1013905,413829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814687 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814687 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]