SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587810 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587810 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614120,52278,895293,724579,5346,563960,633898,677551,874997,514907,467990,298911,819268,764879,567907,770074,513997,162139,1009375,271445,737258,772003,13327,285667,334184,873269,923276,87233,293015,442438,692099,49519,422159,545099,347387,139105,303119,540189,97302,547147,219470,629214,637301,405713,226572,23321,406019,511997,68568,949634,372587,419712,690584,313651,112544,328654,937508,120924,669505,369778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]