SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018711 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018711 [ RunTime:0.002154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392703,727162,530919,900079,116381,612148,170846,145846,974689,716397,65680,786378,752398,677036,1043316,699201,315931,519423,552025,582593,437913,781631,723225,168979,592193,338959,274204,524754,618237,754240,884002,148393,322030,1027117,412745,364287,147867,958802,533412,173147,995082,90670,635211,213097,97948,991223,447887,104308,135276,283689,974663,699665,1033079,678278,143614,184466,358823,778274,607567,867313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]