SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542584 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542584 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700377,231049,189573,387451,796002,231169,72887,661212,477127,706980,452174,971217,964871,779924,524886,98497,705668,824695,491260,139247,646386,151150,771765,103862,955979,293139,977615,931189,990795,444844,813924,30698,903615,823066,762974,139629,456356,254140,494612,559734,918729,973916,96330,737638,752327,1010991,298605,525162,652607,1025752,767379,613411,972549,652678,928472,483944,756789,144529,812212,772142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]