SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406237 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406237 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833810,767439,497008,773656,550676,985033,980072,147213,254931,404069,70914,715742,442552,64136,975760,592501,361653,452496,43221,1016908,866264,4705,871659,485862,997199,412776,1002448,1036940,658086,765745,457728,453395,131379,86918,706777,75796,293343,670104,936502,424351,474610,373441,333951,219292,242709,292499,968048,666830,849503,589054,833296,396103,331745,411277,1009876,765648,241452,905023,294477,292460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406237 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406237 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]