SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548196 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548196 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293795,352774,861620,41178,739989,348880,561084,794223,518958,771252,980471,155995,883106,231305,710739,360762,431980,210891,996407,676670,323548,1007169,178580,284501,371715,466343,334610,557633,269733,653890,585075,882432,466396,583647,72281,641067,1041700,831999,183947,228357,558110,553897,855396,59467,75487,936565,652151,1022521,1025068,519668,532187,873180,853982,895645,474679,507864,315242,205646,87255,486973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001879s ]