SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 912948 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 912948 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644417,673210,704068,270100,174308,60779,444086,1028120,800052,5364,530666,259368,992865,916078,98572,469646,854384,808410,897210,329580,726023,5067,805012,410836,892273,643234,521419,374923,955698,684441,1033910,31763,694548,169643,609405,381535,209879,700177,119709,831597,909447,421533,904058,1031917,843178,79297,617522,226652,578662,965145,236652,111304,588463,350814,56281,40215,928248,204904,987481,469763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 912948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 912948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]