SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407228 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407228 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181775,859998,10493,442512,354676,879989,299623,408401,321320,208890,798561,12863,160972,811013,778042,871549,182264,577499,474182,520439,48869,89665,853575,539983,279864,461737,67002,231215,465508,216073,184102,212101,268562,627530,598367,450465,433599,796681,355098,272724,691673,185334,296700,594850,70102,570076,828933,828233,950379,613191,456111,902824,547041,58561,678390,380421,389459,1005388,584361,693916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]