SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011027 LIMIT 1 [ RunTime:0.000534s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011027 [ RunTime:0.002443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343647,21843,635019,487601,541187,18158,241388,677104,760085,53216,961696,865677,559282,33436,865029,387562,314916,338540,16782,50638,1022504,125642,289510,13687,582006,433582,667797,824369,476493,911624,918007,218108,311215,210826,891554,80260,977833,429088,214684,342947,800609,607558,523343,325238,133290,210015,648580,386839,676486,342973,589209,96237,1010485,1020690,11753,840827,753781,214989,545574,393248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]