SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802071 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802071 [ RunTime:0.002074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809221,898497,122545,312782,807110,199094,933084,195056,985023,377417,689060,860810,754921,83780,649419,135998,714899,297077,1012843,143027,512151,725877,400778,785961,29820,608069,901505,869864,750932,511067,470018,129719,903980,983167,721663,412483,836254,531290,400929,360488,337080,901638,419912,70861,508556,996065,389174,958054,229761,182228,415464,596643,353606,857812,560181,685547,228854,983604,935596,377553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]