SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414045 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414045 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49662,670096,981890,43135,589305,776540,885665,475048,611173,608654,267124,70980,623241,230424,764581,265475,28724,266025,800328,873035,826855,469166,997301,667297,989847,316595,178432,769629,729187,867217,160328,411573,109492,583466,774999,572687,161777,179895,11884,917388,539760,957764,655135,934861,1026992,315709,363347,242004,807097,123682,549565,451412,163660,976701,956194,402426,103470,340359,327929,55086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]