SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420896 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420896 [ RunTime:0.003568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122319,528426,545834,510610,379018,761168,157792,599534,753427,929511,206938,267423,880081,526880,816725,519276,229517,606100,180036,416001,817068,847839,480965,563013,149524,7674,15339,682140,431646,1038303,674326,167383,954808,803438,470039,460881,459037,1037363,537441,953775,132434,821944,553160,241125,178510,791842,114058,700354,585468,1022082,620933,502069,1010321,933496,746588,43812,552967,829961,902670,514086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001852s ]