SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003599s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550098 LIMIT 1 [ RunTime:0.002425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550098 [ RunTime:0.006984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348865,950911,180810,114409,872522,637999,531602,42784,390038,476083,392830,450413,242483,988840,492691,979852,144898,662200,1896,225871,169056,393148,112364,589922,123150,877675,811052,113969,129925,460644,1014659,593021,257790,217907,486078,926616,941975,406804,169655,446764,29961,278168,1021737,860659,322179,65382,509915,779736,657018,344192,421156,395983,957051,994583,477837,272397,1006974,659402,645161,723159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004802s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001771s ]