SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438405 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438405 [ RunTime:0.003664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801897,507209,642951,549737,752189,83604,18618,271509,242393,953715,584085,48672,637317,381751,316796,442505,865499,749504,48062,633513,445365,1031011,400429,774037,246160,853929,534336,346850,820647,834742,857984,540100,406057,103194,372941,776526,988768,107160,404549,648066,970938,156928,955473,651209,564113,906434,214427,689623,140025,776607,436054,727865,728561,573953,1039175,730593,217697,412372,1048402,286150) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000738s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]