SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802581 LIMIT 1 [ RunTime:0.002270s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802581 [ RunTime:0.002954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18260,428193,445885,690235,541679,1001749,396132,895643,58841,726542,157069,375967,254179,614435,373191,981227,592473,228836,939875,657182,67219,827701,366274,219736,956499,758362,590805,3539,757876,646294,468972,469519,538281,17940,478036,809105,855682,664361,386160,987457,736696,853542,30330,112403,286535,196356,86176,157169,645584,1002222,417853,505819,423395,255510,726016,963117,323516,630691,35867,376385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003169s ]