SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51341 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51341 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534014,306045,738204,770494,815143,770383,532208,51905,105079,915845,718333,339662,582086,799402,179663,213439,123941,330390,59759,766350,478806,158970,976088,542977,573002,352160,998890,356757,499781,459597,892122,21063,312855,835868,682071,933856,286902,985229,953821,84676,395610,811713,293582,762768,310499,820315,521527,233773,497394,909584,698672,889296,197597,1020200,864444,763994,275970,233668,600810,646393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]