SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544681 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544681 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905454,906309,803870,733648,53634,724897,984010,221936,170786,460841,232129,1039450,849239,740243,983128,713369,507151,474579,525774,117581,726045,892706,336654,1043259,99138,716967,555842,601455,459740,944813,339317,274032,91445,64401,730726,143750,98778,644448,248101,394337,911260,988630,929639,471909,582830,389583,759906,336197,216679,622266,892060,45730,750415,912183,403085,222028,793233,740818,110938,556594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]