SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003881s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504226 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504226 [ RunTime:0.002822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936317,819636,98422,72419,39262,683097,114191,134534,733356,39628,1009369,582320,80842,1028463,218067,978198,468605,288140,778992,813018,734431,181581,291758,854677,137761,960185,46905,264602,1026698,298012,410547,936512,34672,543889,767771,710863,653658,347313,564477,2168,350177,289090,42269,997447,833568,185853,999101,589126,347156,285179,216990,213236,221913,273394,583626,943880,855709,246852,199097,651726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]