SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536515 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536515 [ RunTime:0.002545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396698,551807,310932,872151,329023,873904,173558,240864,173853,1032670,284238,415532,958583,672943,973913,709244,973492,812136,981982,427792,831265,225999,364922,645421,664284,469682,541646,625874,1004588,239433,740427,611198,222576,1015409,443775,409788,703676,424930,812730,738145,416454,58457,742060,1041233,853717,710695,67550,830461,796994,1029575,32185,460187,976875,420557,746914,168710,928637,965930,396833,756980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]