SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681981 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681981 [ RunTime:0.002974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035075,892779,861904,777078,334228,59388,249440,974861,526031,526926,609503,19663,258548,630172,512752,918136,384763,830042,35635,481142,397259,808437,447239,70838,785347,457883,902258,323525,514228,67211,518030,669966,115211,877740,922605,102122,47092,663764,55291,572751,573477,443220,161563,603314,527412,948433,707091,828534,960970,153247,408990,255638,526355,811541,432159,371169,750374,729855,534530,866126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001341s ]