SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477580 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477580 [ RunTime:0.002525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102426,848218,396724,907928,336180,147897,619334,340268,363639,1004296,334653,765317,763890,393359,214916,113555,886884,562572,793258,427131,40134,386368,630765,456528,210705,168324,977489,1038354,525104,625573,177368,211765,624489,177343,274292,501790,167607,605384,446360,144266,643311,592305,109517,120660,1006726,198750,877792,530759,145250,719562,523834,137659,581456,959530,737417,834012,946329,877888,140013,681020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]