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` = 325401 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325401 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974566,684718,523287,909865,386954,760029,318507,331813,533970,146455,646003,43379,110320,234595,168708,421798,613425,185336,532190,49091,786995,226015,795127,111861,775070,593983,238059,67443,626123,369212,450290,109704,78006,870304,615366,697541,333425,723062,441288,478558,376098,752777,906836,92476,173824,996465,915686,545061,671403,98651,919244,333819,310476,791149,814423,928667,197397,661777,863381,968059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003609s ]