SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563100 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563100 [ RunTime:0.002230s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811387,631174,61593,811969,122781,19984,213615,519687,796784,433580,36445,677227,348631,645617,998261,440351,200426,661202,14447,822589,62349,538593,643778,953948,683668,15122,615164,282364,952038,317438,826304,173268,50032,987507,574831,829316,1046283,399094,643006,688212,932688,589959,169345,407472,555070,806237,744204,60772,793581,713609,770986,997626,242390,229772,735113,756350,879386,718491,12793,754888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]