SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524511 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524511 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172846,430157,182222,866966,329168,1034356,355907,196118,580718,348522,104578,870282,1023996,98613,105266,875509,182290,693007,27106,729449,320714,256733,691801,492393,135776,443485,653125,400900,423819,414313,390700,244495,28970,933272,895683,846554,124103,661053,823918,726361,986607,141819,733792,800134,103902,681014,111191,423229,704073,817885,687026,584259,585877,1016900,893349,810320,176314,462396,648939,452383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]