SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425867 LIMIT 1 [ RunTime:0.000991s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425867 [ RunTime:0.002594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548993,64640,890257,765947,166100,139095,483005,775785,152071,753250,478863,9904,967763,994587,55946,251617,342836,327067,51809,829249,877413,613582,928149,39097,222328,316100,200750,576586,115072,1041686,392071,184237,789546,205854,4456,449493,75363,561446,149799,274302,718850,897904,1040869,865598,755485,776403,702696,732819,892265,660939,416269,697153,772271,590384,375471,84173,68353,123500,436666,327764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425867 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425867 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]