SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001800s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505946 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505946 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587431,423848,396607,239789,202570,136568,374412,631363,232881,597139,219467,208146,79420,214075,134676,450446,559440,1002060,542626,35570,583553,987400,915444,627429,400080,417294,357547,208151,938730,543606,164387,367945,864952,122871,752925,60150,915162,9729,311123,233042,1019305,296160,32723,484931,726980,89066,1041043,412879,577380,177153,943075,1047194,779907,934454,803357,590383,452911,763793,943885,268708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]