SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 675181 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 675181 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520704,97202,968162,459621,90563,915414,391714,251904,969941,418807,685631,906767,190146,414184,826070,191661,339877,873637,266158,117658,37530,1034295,650934,403501,367282,558901,95150,957883,872841,426101,532177,487599,1048493,721041,139388,274619,288769,896828,1007294,235714,426182,440792,643238,422908,810669,1043574,838163,77048,684153,372184,725026,4877,766300,760507,546527,272112,208348,254473,427770,706167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 675181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 675181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000884s ]