SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012175 LIMIT 1 [ RunTime:0.004214s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012175 [ RunTime:0.002929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546393,339733,126756,465408,866327,490224,1018016,421902,645367,515835,1047146,854867,922793,280816,958439,630431,303725,590911,212045,601649,220131,212743,1024200,437176,973662,939163,141919,519554,453519,1026366,31604,64205,959244,679261,723146,284358,892787,442448,95667,891205,1019990,253462,963810,868516,88127,944107,1004963,647501,87871,59857,643819,801021,369910,553525,450916,565970,6885,347546,435374,901500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001210s ]