SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001655s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511672 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511672 [ RunTime:0.002948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243806,38833,599096,445570,988446,518879,287662,20841,1017622,310127,921892,317945,714203,247231,168161,79872,482592,133750,771432,675693,621484,469083,187731,34051,144244,820295,247575,430021,125664,729274,615851,242559,942193,177485,80047,320554,765058,212374,64743,689236,939513,488954,143473,386689,776187,148045,482479,941310,826940,85435,97015,217193,930037,407273,42888,548407,630719,990881,831724,80746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511672 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511672 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006122s ]