SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104562 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104562 [ RunTime:0.005763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358472,817295,70860,822681,861956,210312,643918,642144,103592,1018545,29733,550657,535087,11074,373823,995517,309629,690979,396464,24269,749554,133663,699563,880111,1006389,730626,305285,971751,590040,513112,61141,822769,983839,858966,617982,544314,854677,96486,1030808,363703,891315,148137,1028977,147176,216386,303726,677589,243378,861420,595620,751347,410603,533099,675139,198363,986912,252663,385947,38985,751692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104562 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104562 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002069s ]