SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011475 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011475 [ RunTime:0.002802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508099,1006352,932457,122667,152067,284542,1038851,430886,604570,81639,137329,246459,477195,1003822,466300,555829,350541,1048749,555776,529310,59750,769295,218913,420819,523446,474069,976705,428412,42274,610844,499676,659374,905305,802409,668760,823892,700565,458909,115845,814985,605603,965622,350184,786219,416692,111533,560710,863907,75360,663780,486611,202749,916979,282331,208900,526052,21646,472633,194774,889835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000840s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001247s ]