SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002463s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 720 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 720 [ RunTime:0.002336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52252,566491,708241,554297,323685,962744,820513,885016,115873,981038,836192,705048,562234,299918,839560,211523,696633,611842,197235,311494,950982,540950,1041003,796435,960029,106411,48660,521673,303956,584580,1010668,359318,854822,379040,342934,98415,72518,28348,145626,991650,740288,139985,799524,993369,434047,256351,811149,298849,466600,174076,224465,745912,90304,124255,693896,820539,75301,41224,849472,769609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 720 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 720 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]