SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557182 LIMIT 1 [ RunTime:0.000626s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557182 [ RunTime:0.002376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717718,864924,38163,447898,191338,833665,386868,896179,748594,916063,520762,796499,399306,457638,7338,140942,804523,592890,636294,440686,78681,854343,1031057,845988,23996,109272,783813,446334,980696,790927,756382,923230,836274,217858,176447,121423,69342,725729,122420,288292,413567,531029,674373,390232,611969,30957,985080,297796,975864,482486,147483,587839,183549,831042,500503,168191,950630,415052,867915,112328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003861s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001197s ]